package com.ws.ssmzongjie3.mapper;

import com.ws.ssmzongjie3.bean.Business;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface BusinessMapper {
    @Insert("insert into business(business_name,business_desc,business_contact,business_phone,is_delete,create_time,update_time) values(#{business_name},#{business_desc},#{business_contact},#{business_phone},0,now(),now())")
    public void insertBusiness(Business business);
    @Delete("delete from business where business_id=#{business_id}")
    public void deleteBusiness(Business business);
    @Select("select * from business where business_id=#{business_id}")
    public Business getBusinessById(Business business);
    public void updateBusiness(Business business);
    public List<Business> listBusiness(Business business);
}
